﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using libDAL;




public sealed class clsGenConstants : IDisposable
{
        
        private cls_DAL _BABBLER;
        private cls_DAL _HUGO;
        private cls_DAL _TestBabbler;
        private cls_DAL _DBTESTBabbler;
        private clsGenConstantsOLEDB _DAL_Oledb; 

        private string strCon_BABBLER = @"Data Source =BABBLER;Initial Catalog =NPCDB;Persist Security Info=True;User ID =jdenpc;Password =JDE95#;Connect Timeout=30";
        private string strCon_HUGO = @"Data Source =HUGO;Initial Catalog =NPC_PROD;Persist Security Info=True;User ID =sa;Password =ADMIN@passw0rd;Connect Timeout=30";
        private string strTestDBJohn = @"Data Source=NPCPLANT-00237\NPCDATABASE;Initial Catalog=MaresTestDatabase;User ID=archie;Password=123";
        private string strConArchieTest = @"Data Source=NPC-00214\ARCHIEDB;Initial Catalog=archieLocal;Integrated Security=True";
        private string strCon_BABBLERTest = @"Data Source =BABBLER;Initial Catalog =TESTDB;Persist Security Info=True;User ID =jdenpc;Password =JDE95#;Connect Timeout=30";
        
        public clsGenConstants()
        {
            _DBTESTBabbler = new cls_DAL(strCon_BABBLERTest); 
            _HUGO = new cls_DAL(strCon_HUGO);
            _BABBLER = new cls_DAL(strCon_BABBLER);
            _TestBabbler = new cls_DAL(strConArchieTest);
         //   _DAL_Oledb = new clsGenConstantsOLEDB(strConStringOLEDB); 
        }

        public cls_DAL get_TeatBablerDalTestDB
        {
            get
            {
                return _DBTESTBabbler;
            }
        }

        public cls_DAL get_TeatArchieDAL
        {
            get
            {
                return _TestBabbler;
            }
        }

        public cls_DAL get_DAL_Hugo
        {
            get
            {
                return _HUGO;
            }
        }

        public cls_DAL get_DAL_Babbler
        {
            get
            {
                return _BABBLER;
            }
        }

        public string get_ConBabbler
        {
            get
            {
                return strCon_BABBLER;
            }
        }

        public string get_ConHUGO
        {
            get
            {
                return strCon_HUGO;
            }
        }

        public string get_ConTestDBJohn
        {
            get
            {
                return strTestDBJohn;
            }
        }

        public string get_ConTestDBArchie
        {
            get
            {
                return strTestDBJohn;
            }
        }


        public void Dispose()
        {
            GC.Collect();
           // throw new NotImplementedException();
        }
}
